CREATE TABLE [dbo].[tb_CargosSalariales]
(
[idCargo] [int] NOT NULL,
[cargo] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Regimensalarial] [int] NOT NULL,
[Escalafon] [int] NOT NULL,
[NumeroOrden] [int] NOT NULL,
[JerarqEscalafon] [int] NOT NULL,
[JerarqInterEscalafon] [int] NOT NULL,
[EquivHoraria] [int] NOT NULL,
[Puntos] [float] NOT NULL,
[SueldoBasico] [float] NOT NULL,
[SuplNoBonif] [float] NULL,
[Mnemo] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CargoGenerico] [int] NULL,
[PuntosSupNoBonif] [float] NULL,
[HorasCat] [int] NULL,
[idCargoSageNacional] [int] NULL,
[idSARH] [int] NULL,
[idCargoSARH] [int] NULL,
[idCategoriaSARH] [int] NULL,
[cobraxHora] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[valor2] [decimal] (8, 2) NULL,
[valor3] [decimal] (8, 2) NULL,
[valor4] [decimal] (8, 2) NULL,
[valor5] [decimal] (8, 2) NULL,
[valor6] [decimal] (8, 2) NULL,
[d_1801_08] [decimal] (8, 2) NULL,
[esDirectivo] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [PK_tb_Cargos] ON [dbo].[tb_CargosSalariales] ([idCargo]) ON [PRIMARY]
GO
